﻿CREATE TABLE [dbo].[tbl_Users] (
    [Id]          BIGINT           NOT NULL IDENTITY,
    [LoginName]  NVARCHAR (50) NOT NULL,
    [Password]   NVARCHAR (130) NOT NULL,
    [AdminLevel] TINYINT        NOT NULL DEFAULT 0,
    [Email] NVARCHAR(50) NOT NULL, 
    [IsEnable] BIT NOT NULL DEFAULT 0, 
    CONSTRAINT [PK_tbl_Users] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO

CREATE INDEX [IX_tbl_Users_Column] ON [dbo].[tbl_Users] ([LoginName])
GO
